Skip Headers

Oracle® Database Reference 10g Release 2 (10.2) Part Number B14237-02 |
Home | Book List | Contents | Index | Master Index | Feedback

Previous | Next
| View PDF

# DBA_RSRC_CONSUMER_GROUP_PRIVS

`DBA_RSRC_CONSUMER_GROUP_PRIVS` displays information about all resource consumer groups and the users and roles assigned to them. The grant referred to in this view and the related view is the grant of the `SWITCH_CONSUMER_GROUP` object privilege, which is granted using the `DBMS_RESOURCE_MANAGER_PRIVS` package. This privilege is not granted through the `GRANT` SQL statement.

Related View

`USER_RSRC_CONSUMER_GROUP_PRIVS` displays information about the resource consumer groups to which the current user is assigned. This view does not display the `GRANTEE` column.

Column | Datatype | NULL | Description
--- | --- | --- | ---
`GRANTEE` | `VARCHAR2(30)` | `NOT NULL` | User or role receiving the grant
`GRANTED_GROUP` | `VARCHAR2(30)` |  | Granted consumer group name
`GRANT_OPTION` | `VARCHAR2(3)` |  | Indicates whether the grant was with the `GRANT` option (`YES`) or not (`NO`)
`INITIAL_GROUP` | `VARCHAR2(3)` |  | Indicates whether the consumer group is designated as the default for this user or role (`YES`) or not (`NO`)

See Also: "USER_RSRC_CONSUMER_GROUP_PRIVS" Oracle Database PL/SQL Packages and Types Reference for more information on consumer group privileges